Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference

SQL Temp Table Data Page (-SQLTempPgSize)

Use SQL Temp Table Data Page (-SQLTempPgSize) to define the size in K-bytes of the temporary table data page, which is the upper limit of temporary table record size.

Operating system and syntax	UNIX Windows	-SQLTempPgSize value
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
SQL	256	4	8	8

value

Size in K-bytes of the temporary table data page.

Increasing the value of -SQLTempPgSize aids sorting data with a large number of values per row.